2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 012 #BIReleases2013

Release Notes:

5910.200 - Contracts - SA230

Admin Info

Purpose
 Including Contract Information in SA230 report
Release No
 012
Submitted
 03-22-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Narendra K
Object(s) Tested By
 Narendra K

Report Name

SA230 - Sales Analysis by Region, Sales Org, License and Team

‍BEx Query

ZMP_OPASA_Q018

NEC Crystal Reports Standards Check

1. SA230 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA230 NEC CR checklist has been sent to NEC and also attached here for reference.
SA230 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Report Header
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 3,080,700
 3,080,700
 Pass
2
 Ship Rev
 31,542,208
 31,542,208
 Pass
3
 Open Qty
 3,376
 3,376
 Pass
4
 Open Rev
 35,045
 35,045
 Pass
5
 Cost
 13,181,371
 13,181,371
 Pass
6
 Comm
 893,035
 893,035
 Pass
7
 Royalty
 4,541,236
 4,541,236
 Pass
8
 Contrib
 13,061,456
 13,061,456
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 4,050,055
 4,050,055
 Pass
2
 Ship Rev
 44,579,749
 44,579,749
 Pass
3
 Open Qty
 795,295
 795,295
 Pass
4
 Open Rev
 9,214,997
 9,214,997
 Pass
5
 Cost
 18,753,268
 18,753,268
 Pass
6
 Comm
 1,181,961
 1,181,961
 Pass
7
 Royalty
 6,480,588
 6,480,588
 Pass
8
 Contrib
 18,555,696
 18,555,696
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,819,250
 1,819,250
 Pass
2
 Ship Rev
 17,923,109
 17,923,109
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 6,993,438
 6,993,438
 Pass
6
 Comm
 609,317
 609,317
 Pass
7
 Royalty
 2,271,941
 2,271,941
 Pass
8
 Contrib
 8,048,412
 8,048,412
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,207,443
 5,207,443
 Pass
2
 Ship Rev
 61,590,962
 61,590,962
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 20,086,092
 20,086,092
 Pass
6
 Comm
 1,769,692
 1,769,692
 Pass
7
 Royalty
 9,280,874
 9,280,874
 Pass
8
 Contrib
 30,454,304
 30,454,304
 Pass

Dynamic Group 1:

‍Test Conducted

Dynamic Grouping Parameter(1) and Group Name: Region > Sales Org > License > Team

‍Summary Level Check

‍Test Conducted

Group: Emerging Markets
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 112,564
 112,564
 Pass
2
 Ship Rev
 1,616,463
 1,616,463
 Pass
3
 Open Qty
 425
 425
 Pass
4
 Open Rev
 5,523
 5,523
 Pass
5
 Cost
 488,797
 488,797
 Pass
6
 Comm
 9,998
 9,998
 Pass
7
 Royalty
 223,577
 223,577
 Pass
8
 Contrib
 894,091
 894,091
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 103,180
 103,180
 Pass
2
 Ship Rev
 1,403,166
 1,403,166
 Pass
3
 Open Qty
 60,000
 60,000
 Pass
4
 Open Rev
 882,953
 882,953
 Pass
5
 Cost
 503,264
 503,264
 Pass
6
 Comm
 8,287
 8,287
 Pass
7
 Royalty
 202,159
 202,159
 Pass
8
 Contrib
 689,456
 689,456
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 59,057
 59,057
 Pass
2
 Ship Rev
 835,799
 835,799
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 252,715
 252,715
 Pass
6
 Comm
 6,073
 6,073
 Pass
7
 Royalty
 133,778
 133,778
 Pass
8
 Contrib
 443,232
 443,232
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 168,503
 168,503
 Pass
2
 Ship Rev
 2,160,878
 2,160,878
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 689,877
 689,877
 Pass
6
 Comm
 10,478
 10,478
 Pass
7
 Royalty
 333,818
 333,818
 Pass
8
 Contrib
 1,126,705
 1,126,705
 Pass

Second Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 13,063
 13,063
 Pass
2
 Ship Rev
 272,973
 272,973
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 62,605
 62,605
 Pass
6
 Comm
 9,386
 9,386
 Pass
7
 Royalty
 37,591
 37,591
 Pass
8
 Contrib
 163,392
 163,392
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 16,936
 16,936
 Pass
2
 Ship Rev
 275,948
 275,948
 Pass
3
 Open Qty
 3,354
 3,354
 Pass
4
 Open Rev
 65,458
 65,458
 Pass
5
 Cost
 78,281
 78,281
 Pass
6
 Comm
 8,089
 8,089
 Pass
7
 Royalty
 39,922
 39,922
 Pass
8
 Contrib
 150,655
 150,655
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 11,323
 11,323
 Pass
2
 Ship Rev
 243,910
 243,910
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 39,317
 39,317
 Pass
6
 Comm
 5,871
 5,871
 Pass
7
 Royalty
 37,960
 37,960
 Pass
8
 Contrib
 160,763
 160,763
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 19,338
 19,338
 Pass
2
 Ship Rev
 348,035
 348,035
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 63,279
 63,279
 Pass
6
 Comm
 10,026
 10,026
 Pass
7
 Royalty
 59,614
 59,614
 Pass
8
 Contrib
 215,117
 215,117
 Pass

Third Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales > MLB PROPERTIES
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,797
 5,797
 Pass
2
 Ship Rev
 110,246
 110,246
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 18,844
 18,844
 Pass
6
 Comm
 3,436
 3,436
 Pass
7
 Royalty
 19,373
 19,373
 Pass
8
 Contrib
 68,592
 68,592
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,128
 5,128
 Pass
2
 Ship Rev
 94,689
 94,689
 Pass
3
 Open Qty
 1,102
 1,102
 Pass
4
 Open Rev
 19,441
 19,441
 Pass
5
 Cost
 19,731
 19,731
 Pass
6
 Comm
 2,548
 2,548
 Pass
7
 Royalty
 17,549
 17,549
 Pass
8
 Contrib
 54,861
 54,861
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,266
 5,266
 Pass
2
 Ship Rev
 113,664
 113,664
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 17,525
 17,525
 Pass
6
 Comm
 3,364
 3,364
 Pass
7
 Royalty
 19,692
 19,692
 Pass
8
 Contrib
 73,082
 73,082
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 9,086
 9,086
 Pass
2
 Ship Rev
 144,417
 144,417
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 28,166
 28,166
 Pass
6
 Comm
 3,893
 3,893
 Pass
7
 Royalty
 32,114
 32,114
 Pass
8
 Contrib
 80,244
 80,244
 Pass

Fourth Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales > MLB PROPERTIES > ATLANTA BRAVES
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 191
 191
 Pass
2
 Ship Rev
 3,803
 3,803
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 599
 599
 Pass
6
 Comm
 130
 130
 Pass
7
 Royalty
 696
 696
 Pass
8
 Contrib
 2,378
 2,378
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 157
 157
 Pass
2
 Ship Rev
 2,671
 2,671
 Pass
3
 Open Qty
 34
 34
 Pass
4
 Open Rev
 612
 612
 Pass
5
 Cost
 734
 734
 Pass
6
 Comm
 85
 85
 Pass
7
 Royalty
 486
 486
 Pass
8
 Contrib
 1,366
 1,366
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 657
 657
 Pass
2
 Ship Rev
 14,188
 14,188
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 2,207
 2,207
 Pass
6
 Comm
 435
 435
 Pass
7
 Royalty
 2,432
 2,432
 Pass
8
 Contrib
 9,114
 9,114
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 245
 245
 Pass
2
 Ship Rev
 6,210
 6,210
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 800
 800
 Pass
6
 Comm
 159
 159
 Pass
7
 Royalty
 1,018
 1,018
 Pass
8
 Contrib
 4,234
 4,234
 Pass

Dynamic Group 2:

‍Test Conducted

Dynamic Grouping Parameter(2) and Group Name: Region > Sales Org > License > Silhouette

‍Summary Level Check

‍Test Conducted

Group: Emerging Markets
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 112,564
 112,564
 Pass
2
 Ship Rev
 1,616,463
 1,616,463
 Pass
3
 Open Qty
 425
 425
 Pass
4
 Open Rev
 5,523
 5,523
 Pass
5
 Cost
 488,797
 488,797
 Pass
6
 Comm
 9,998
 9,998
 Pass
7
 Royalty
 223,577
 223,577
 Pass
8
 Contrib
 894,091
 894,091
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 103,180
 103,180
 Pass
2
 Ship Rev
 1,403,166
 1,403,166
 Pass
3
 Open Qty
 60,000
 60,000
 Pass
4
 Open Rev
 882,953
 882,953
 Pass
5
 Cost
 503,264
 503,264
 Pass
6
 Comm
 8,287
 8,287
 Pass
7
 Royalty
 202,159
 202,159
 Pass
8
 Contrib
 689,456
 689,456
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 59,057
 59,057
 Pass
2
 Ship Rev
 835,799
 835,799
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 252,715
 252,715
 Pass
6
 Comm
 6,073
 6,073
 Pass
7
 Royalty
 133,778
 133,778
 Pass
8
 Contrib
 443,232
 443,232
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 168,503
 168,503
 Pass
2
 Ship Rev
 2,160,878
 2,160,878
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 689,877
 689,877
 Pass
6
 Comm
 10,478
 10,478
 Pass
7
 Royalty
 333,818
 333,818
 Pass
8
 Contrib
 1,126,705
 1,126,705
 Pass

Second Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 13,063
 13,063
 Pass
2
 Ship Rev
 272,973
 272,973
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 62,605
 62,605
 Pass
6
 Comm
 9,386
 9,386
 Pass
7
 Royalty
 37,591
 37,591
 Pass
8
 Contrib
 163,392
 163,392
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 16,936
 16,936
 Pass
2
 Ship Rev
 275,948
 275,948
 Pass
3
 Open Qty
 3,354
 3,354
 Pass
4
 Open Rev
 65,458
 65,458
 Pass
5
 Cost
 78,281
 78,281
 Pass
6
 Comm
 8,089
 8,089
 Pass
7
 Royalty
 39,922
 39,922
 Pass
8
 Contrib
 150,655
 150,655
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 11,323
 11,323
 Pass
2
 Ship Rev
 243,910
 243,910
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 39,317
 39,317
 Pass
6
 Comm
 5,871
 5,871
 Pass
7
 Royalty
 37,960
 37,960
 Pass
8
 Contrib
 160,763
 160,763
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 19,338
 19,338
 Pass
2
 Ship Rev
 348,035
 348,035
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 63,279
 63,279
 Pass
6
 Comm
 10,026
 10,026
 Pass
7
 Royalty
 59,614
 59,614
 Pass
8
 Contrib
 215,117
 215,117
 Pass

Third Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales > MLB PROPERTIES
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,797
 5,797
 Pass
2
 Ship Rev
 110,246
 110,246
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 18,844
 18,844
 Pass
6
 Comm
 3,436
 3,436
 Pass
7
 Royalty
 19,373
 19,373
 Pass
8
 Contrib
 68,592
 68,592
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,128
 5,128
 Pass
2
 Ship Rev
 94,689
 94,689
 Pass
3
 Open Qty
 1,102
 1,102
 Pass
4
 Open Rev
 19,441
 19,441
 Pass
5
 Cost
 19,731
 19,731
 Pass
6
 Comm
 2,548
 2,548
 Pass
7
 Royalty
 17,549
 17,549
 Pass
8
 Contrib
 54,861
 54,861
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 5,266
 5,266
 Pass
2
 Ship Rev
 113,664
 113,664
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 17,525
 17,525
 Pass
6
 Comm
 3,364
 3,364
 Pass
7
 Royalty
 19,692
 19,692
 Pass
8
 Contrib
 73,082
 73,082
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 9,086
 9,086
 Pass
2
 Ship Rev
 144,417
 144,417
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 28,166
 28,166
 Pass
6
 Comm
 3,893
 3,893
 Pass
7
 Royalty
 32,114
 32,114
 Pass
8
 Contrib
 80,244
 80,244
 Pass

Fourth Level Check

‍‍‍‍‍Test Conducted

Group: Emerging Markets > Australia Sales > MLB PROPERTIES > 5950
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,264
 1,264
 Pass
2
 Ship Rev
 30,858
 30,858
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 3,759
 3,759
 Pass
6
 Comm
 748
 748
 Pass
7
 Royalty
 4,974
 4,974
 Pass
8
 Contrib
 21,377
 21,377
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 2,172
 2,172
 Pass
2
 Ship Rev
 41,239
 41,239
 Pass
3
 Open Qty
 244
 244
 Pass
4
 Open Rev
 5,862
 5,862
 Pass
5
 Cost
 8,404
 8,404
 Pass
6
 Comm
 1,190
 1,190
 Pass
7
 Royalty
 6,979
 6,979
 Pass
8
 Contrib
 24,666
 24,666
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 3,262
 3,262
 Pass
2
 Ship Rev
 72,612
 72,612
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 10,782
 10,782
 Pass
6
 Comm
 2,126
 2,126
 Pass
7
 Royalty
 11,482
 11,482
 Pass
8
 Contrib
 48,221
 48,221
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 3,785
 3,785
 Pass
2
 Ship Rev
 60,405
 60,405
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 11,789
 11,789
 Pass
6
 Comm
 1,395
 1,395
 Pass
7
 Royalty
 14,289
 14,289
 Pass
8
 Contrib
 32,892
 32,892
 Pass

Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports